<?php
header('content-type:text/html;charset=utf-8');
$link=mysqli_connect('localhost','root','');
if (!$link){
    die('连接数据库失败!'.mysqli_error($link));
}
mysqli_query($link,'set names utf8');
mysqli_query($link,'use `itcast`');


$page_size=2;
$res = mysqli_query($link,'select count(*) from  `emp_info`');
//if(!$res)die();
$count=mysqli_fetch_row($res);
$count=$count[0];
$max_page=ceil($count/$page_size);
$page = isset($_GET['page']) ? intval($_GET['page']):1;
$page = $page > $max_page ? $max_page : $page;
$page = $page < 1 ? 1 : $page;

$page_html="<a href='./showlist.php?page=1'>首页</a>&nbsp;";
$page_html.="<a href='./showlist.php?page=".(($page-1)>0 ? ($page-1) : 1)."'>上一页</a>&nbsp;";
$page_html.="<a href='./showlist.php?page=".(($page+1) < $max_page ? ($page+1) : $max_page)."'>下一页</a>&nbsp;";
$page_html.="<a href='./showlist.php?page={$max_page}'>尾页</a>";
$lim=($page-1)*$page_size;


$sql="select* from emp_info limit {$lim},{$page_size}";
$res=mysqli_query($link,$sql);
//if(!$res)die();

$emp_info=array();
while($row=mysqli_fetch_assoc($res)){
    $emp_info[]=$row;
}
define('APP','itcast');
require './list_html.php';




